<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="en-us" xml:lang="en-us">
 <head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="DC.Type" content="topic">
  <meta name="DC.Title" content="Querying DB2 Information">
  <meta name="product" content="">
  <meta name="DC.Relation" scheme="URI" content="en-us_topic_0000002200142005.html">
  <meta name="prodname" content="">
  <meta name="version" content="">
  <meta name="brand" content="">
  <meta name="DC.Publisher" content="20250306">
  <meta name="prodname" content="csbs">
  <meta name="documenttype" content="usermanual">
  <meta name="DC.Format" content="XHTML">
  <meta name="DC.Identifier" content="EN-US_TOPIC_0000002200056449">
  <meta name="DC.Language" content="en-us">
  <link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
  <title>Querying DB2 Information</title>
 </head>
 <body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px">
  <a name="EN-US_TOPIC_0000002200056449"></a><a name="EN-US_TOPIC_0000002200056449"></a>
  <h1 class="topictitle1">Querying DB2 Information</h1>
  <div>
   <div class="section">
    <h4 class="sectiontitle">Procedure</h4>
    <ol>
     <li><span>Choose <span class="uicontrol" id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002199964685_uicontrol21435597359"><b><span id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002199964685_text4379114911434"><strong>Protection</strong></span> &gt; Databases &gt; DB2</b></span>.</span></li>
     <li><span>On the <span class="uicontrol"><b>Cluster</b></span> tab page, query the DB2 cluster information.</span><p></p>
      <ol type="a">
       <li>View information about DB2 clusters registered with the <span>product</span>.<p><a href="#EN-US_TOPIC_0000002200056449__table14170211115420">Table 1</a> describes the related parameters.</p>
        <div class="note">
         <img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span>
         <div class="notebody">
          <p id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_p4219634163218">Some parameters are not displayed by default. You can click <span><img id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_image1271105319486" src="en-us_image_0000002200147221.png"></span> next to <strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b9551254456">Operation</strong> and select a parameter to display it on the current page.</p>
         </div>
        </div>
        <div class="tablenoborder">
         <a name="EN-US_TOPIC_0000002200056449__table14170211115420"></a><a name="table14170211115420"></a>
         <table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000002200056449__table14170211115420" frame="border" border="1" rules="all">
          <caption>
           <b>Table 1 </b>DB2 cluster information
          </caption>
          <colgroup>
           <col style="width:19.189999999999998%">
           <col style="width:80.81%">
          </colgroup>
          <thead align="left">
           <tr>
            <th align="left" class="cellrowborder" valign="top" width="19.189999999999998%" id="mcps1.3.1.2.2.2.1.1.4.2.3.1.1"><p>Parameter</p></th>
            <th align="left" class="cellrowborder" valign="top" width="80.81%" id="mcps1.3.1.2.2.2.1.1.4.2.3.1.2"><p>Description</p></th>
           </tr>
          </thead>
          <tbody>
           <tr>
            <td class="cellrowborder" valign="top" width="19.189999999999998%" headers="mcps1.3.1.2.2.2.1.1.4.2.3.1.1 "><p><strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b2729746822433">Name</strong></p></td>
            <td class="cellrowborder" valign="top" width="80.81%" headers="mcps1.3.1.2.2.2.1.1.4.2.3.1.2 "><p>DB2 cluster name.</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="19.189999999999998%" headers="mcps1.3.1.2.2.2.1.1.4.2.3.1.1 "><p><strong>Status</strong></p></td>
            <td class="cellrowborder" valign="top" width="80.81%" headers="mcps1.3.1.2.2.2.1.1.4.2.3.1.2 "><p>DB2 cluster status.</p>
             <ul>
              <li><strong>Online</strong>: If the connections between the <span>product</span> and all nodes in the DB2 cluster are normal, <strong>Status</strong> is <strong>Online</strong>.</li>
              <li><strong>Offline</strong>: If the connections between the <span>product</span> and all nodes in the DB2 cluster are abnormal, <strong>Status</strong> is <strong>Offline</strong>.</li>
             </ul></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="19.189999999999998%" headers="mcps1.3.1.2.2.2.1.1.4.2.3.1.1 "><p><strong>Type</strong></p></td>
            <td class="cellrowborder" valign="top" width="80.81%" headers="mcps1.3.1.2.2.2.1.1.4.2.3.1.2 "><p>Cluster type.</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="19.189999999999998%" headers="mcps1.3.1.2.2.2.1.1.4.2.3.1.1 ">
             <div class="p">
              <strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b827118125517">Tag</strong>
              <div class="note" id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_note1330311543247">
               <span class="notetitle"> NOTE: </span>
               <div class="notebody">
                <p id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_p630385412417"><span id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_ph5374928181810">This parameter is available only in 1.6.0 and later versions.</span></p>
               </div>
              </div>
             </div></td>
            <td class="cellrowborder" valign="top" width="80.81%" headers="mcps1.3.1.2.2.2.1.1.4.2.3.1.2 "><p>If a tag has been added for the resource, the tag name is displayed. Otherwise, <strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b1959642011219">--</strong> is displayed.</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="19.189999999999998%" headers="mcps1.3.1.2.2.2.1.1.4.2.3.1.1 ">
             <div class="p">
              <span id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_text1045121611529"><strong>Owner</strong></span>
              <div class="note" id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_note6159153035311">
               <span class="notetitle"> NOTE: </span>
               <div class="notebody">
                <p id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_p815914301534">This parameter is available only in 1.5.0.</p>
               </div>
              </div>
             </div></td>
            <td class="cellrowborder" valign="top" width="80.81%" headers="mcps1.3.1.2.2.2.1.1.4.2.3.1.2 "><p>Data protection administrator of a host or cluster.</p> <p>If a host or cluster has been authorized to a data protection administrator, the name of the data protection administrator is displayed. If no data protection administrator is authorized, <strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b1022551410446">--</strong> is displayed.</p></td>
           </tr>
          </tbody>
         </table>
        </div></li>
       <li>Click a cluster name to view the cluster basic information and the information about databases related to the cluster.</li>
      </ol> <p></p></li>
     <li><span>On the <strong>Instance</strong> tab page, query the DB2 instance information.</span><p></p>
      <ol type="a">
       <li>View details about DB2 instances.<p><a href="#EN-US_TOPIC_0000002200056449__table122748567413">Table 2</a> describes the related parameters.</p>
        <div class="note">
         <img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span>
         <div class="notebody">
          <p id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_p4219634163218_1">Some parameters are not displayed by default. You can click <span><img id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_image1271105319486_1" src="en-us_image_0000002200147221.png"></span> next to <strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b9551254456_1">Operation</strong> and select a parameter to display it on the current page.</p>
         </div>
        </div>
        <div class="tablenoborder">
         <a name="EN-US_TOPIC_0000002200056449__table122748567413"></a><a name="table122748567413"></a>
         <table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000002200056449__table122748567413" frame="border" border="1" rules="all">
          <caption>
           <b>Table 2 </b>DB2 instance parameters
          </caption>
          <colgroup>
           <col style="width:25.55%">
           <col style="width:74.45%">
          </colgroup>
          <thead align="left">
           <tr>
            <th align="left" class="cellrowborder" valign="top" width="25.55%" id="mcps1.3.1.2.3.2.1.1.3.2.3.1.1"><p>Parameter</p></th>
            <th align="left" class="cellrowborder" valign="top" width="74.45%" id="mcps1.3.1.2.3.2.1.1.3.2.3.1.2"><p>Description</p></th>
           </tr>
          </thead>
          <tbody>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.3.2.1.1.3.2.3.1.1 "><p><strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b2729746822433_1">Name</strong></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.3.2.1.1.3.2.3.1.2 "><p>Instance name.</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.3.2.1.1.3.2.3.1.1 "><p><strong>Status</strong></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.3.2.1.1.3.2.3.1.2 "><p>Instance status.</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.3.2.1.1.3.2.3.1.1 "><p id="EN-US_TOPIC_0000002200056449__p81881034121216"><strong id="EN-US_TOPIC_0000002200056449__b716145510445">Owning Host/Cluster</strong></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.3.2.1.1.3.2.3.1.2 "><p>Host or cluster to which a instance belongs.</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.3.2.1.1.3.2.3.1.1 "><p><strong>Version</strong></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.3.2.1.1.3.2.3.1.2 "><p>Instance version.</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.3.2.1.1.3.2.3.1.1 ">
             <div class="p">
              <strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b827118125517_1">Tag</strong>
              <div class="note" id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_note1330311543247_1">
               <span class="notetitle"> NOTE: </span>
               <div class="notebody">
                <p id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_p630385412417_1"><span id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_ph5374928181810_1">This parameter is available only in 1.6.0 and later versions.</span></p>
               </div>
              </div>
             </div></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.3.2.1.1.3.2.3.1.2 "><p>If a tag has been added for the resource, the tag name is displayed. Otherwise, <strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b1959642011219_1">--</strong> is displayed.</p></td>
           </tr>
          </tbody>
         </table>
        </div></li>
      </ol>
      <ol type="a" start="2">
       <li>Click a name and check the basic information and databases. 
        <ul>
         <li>Basic information<p>Displays the instance name, owing host/cluster, version, and node information.</p></li>
         <li>Databases<p>Displays the database name, SLAs, SLA compliance, and protection status.</p></li>
        </ul></li>
      </ol> <p></p></li>
     <li><span>On the <strong>Databases</strong> tab page, query the DB2 database information.</span><p></p>
      <ol type="a">
       <li>View details about DB2 databases.<p><a href="#EN-US_TOPIC_0000002200056449__table140423282011">Table 3</a> describes the related parameters.</p>
        <div class="note">
         <img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span>
         <div class="notebody">
          <p id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_p4219634163218_2">Some parameters are not displayed by default. You can click <span><img id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_image1271105319486_2" src="en-us_image_0000002200147221.png"></span> next to <strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b9551254456_2">Operation</strong> and select a parameter to display it on the current page.</p>
         </div>
        </div>
        <div class="tablenoborder">
         <a name="EN-US_TOPIC_0000002200056449__table140423282011"></a><a name="table140423282011"></a>
         <table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000002200056449__table140423282011" frame="border" border="1" rules="all">
          <caption>
           <b>Table 3 </b>DB2 database parameters
          </caption>
          <colgroup>
           <col style="width:25.55%">
           <col style="width:74.45%">
          </colgroup>
          <thead align="left">
           <tr>
            <th align="left" class="cellrowborder" valign="top" width="25.55%" id="mcps1.3.1.2.4.2.1.1.3.2.3.1.1"><p>Parameter</p></th>
            <th align="left" class="cellrowborder" valign="top" width="74.45%" id="mcps1.3.1.2.4.2.1.1.3.2.3.1.2"><p>Description</p></th>
           </tr>
          </thead>
          <tbody>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.4.2.1.1.3.2.3.1.1 "><p><strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b2729746822433_2">Name</strong></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.4.2.1.1.3.2.3.1.2 "><p>Database name.</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.4.2.1.1.3.2.3.1.1 "><p><strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002200056449_b716145510445">Owning Host/Cluster</strong></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.4.2.1.1.3.2.3.1.2 "><p>Host or cluster to which a database belongs.</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.4.2.1.1.3.2.3.1.1 "><p><strong>Owning Instance</strong></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.4.2.1.1.3.2.3.1.2 "><p>Instance to which a database belongs.</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.4.2.1.1.3.2.3.1.1 "><p><strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b925671019379">SLAs</strong></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.4.2.1.1.3.2.3.1.2 "><p>If an SLA has been associated with a DB2 database, the SLA name is displayed. Otherwise, <strong>--</strong> is displayed.</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.4.2.1.1.3.2.3.1.1 "><p><strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b2087113375371">SLA Compliance</strong></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.4.2.1.1.3.2.3.1.2 ">
             <div class="p">
              Whether a backup job is successfully executed based on the backup interval or backup window set in the SLA.
              <ul id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_en-us_topic_0000002164820450_ul1823814519293">
               <li id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_en-us_topic_0000002164820450_li9238184572919"><strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_en-us_topic_0000002164820450_b1092516394564">Met</strong>: If the backup time of a backup job (except for the first full backup) meets the backup time window or backup interval requirements and the backup job is executed successfully, SLA compliance is met.</li>
               <li id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_en-us_topic_0000002164820450_li189142052112912"><strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_en-us_topic_0000002164820450_b541520442564">Missed</strong>: If the backup time does not meet the backup time window or backup interval requirements, for example, if the backup interval set in the SLA for a backup job is once every half an hour but the backup time exceeds half an hour, SLA compliance is missed. In this case, you are advised to adjust the backup interval or backup window.</li>
              </ul>
             </div></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.4.2.1.1.3.2.3.1.1 "><p><strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b5758164315376">Protection Status</strong></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.4.2.1.1.3.2.3.1.2 "><p>Whether a DB2 database has been protected.</p>
             <ul>
              <li id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_li11611621173118"><strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b884464214219">Unprotected</strong>: The current resource is not associated with an SLA, or the resource is associated with an SLA but protection is disabled.</li>
              <li id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_li761111211312"><strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b10824655184216">Protected</strong>: The current resource is associated with an SLA and protection is activated.</li>
              <li id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_li2088261163715"><strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b67140854310">Creating</strong>: The current resource is associated with an SLA and protection is being created.</li>
             </ul></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.4.2.1.1.3.2.3.1.1 ">
             <div class="p">
              <strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b827118125517_2">Tag</strong>
              <div class="note" id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_note1330311543247_2">
               <span class="notetitle"> NOTE: </span>
               <div class="notebody">
                <p id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_p630385412417_2"><span id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_ph5374928181810_2">This parameter is available only in 1.6.0 and later versions.</span></p>
               </div>
              </div>
             </div></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.4.2.1.1.3.2.3.1.2 "><p>If a tag has been added for the resource, the tag name is displayed. Otherwise, <strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b1959642011219_2">--</strong> is displayed.</p></td>
           </tr>
          </tbody>
         </table>
        </div></li>
       <li id="EN-US_TOPIC_0000002200056449__li1110073132119">Click a name and check the overview, copy information, and related jobs. 
        <ul id="EN-US_TOPIC_0000002200056449__ul610053152120">
         <li id="EN-US_TOPIC_0000002200056449__li910016322113">Overview<p id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_p18940145516325"><a name="EN-US_TOPIC_0000002200056449__li910016322113"></a><a name="li910016322113"></a>Display the SLA information, job execution time, and total number of copies.</p></li>
         <li id="EN-US_TOPIC_0000002200056449__li17100173162115">Copy data<p id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_p565454392218"><a name="EN-US_TOPIC_0000002200056449__li17100173162115"></a><a name="li17100173162115"></a>You can search for copies by year, month, and day.</p> <p id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_p6521122942916">If <span><img id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_image7611125417346" src="en-us_image_0000002164820646.png"></span> is displayed below the time, a copy exists at the time.</p></li>
         <li id="EN-US_TOPIC_0000002200056449__li61008392112">Operation<p id="EN-US_TOPIC_0000002200056449__p101003314212"><a name="EN-US_TOPIC_0000002200056449__li61008392112"></a><a name="li61008392112"></a>Displays all jobs related to a database, such as backup, restoration, and replication jobs. You can choose to display ongoing or historical jobs.</p></li>
        </ul></li>
      </ol> <p></p></li>
     <li><span>On the <strong>Tablespace Set</strong> tab page, query the DB2 tablespace set information.</span><p></p>
      <ol type="a">
       <li>View details about DB2 tablespace sets.<p><a href="#EN-US_TOPIC_0000002200056449__table19966163675618">Table 4</a> describes the related parameters.</p>
        <div class="note">
         <img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span>
         <div class="notebody">
          <p id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_p4219634163218_3">Some parameters are not displayed by default. You can click <span><img id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_image1271105319486_3" src="en-us_image_0000002200147221.png"></span> next to <strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b9551254456_3">Operation</strong> and select a parameter to display it on the current page.</p>
         </div>
        </div>
        <div class="tablenoborder">
         <a name="EN-US_TOPIC_0000002200056449__table19966163675618"></a><a name="table19966163675618"></a>
         <table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000002200056449__table19966163675618" frame="border" border="1" rules="all">
          <caption>
           <b>Table 4 </b>DB2 tablespace set parameters
          </caption>
          <colgroup>
           <col style="width:25.55%">
           <col style="width:74.45%">
          </colgroup>
          <thead align="left">
           <tr>
            <th align="left" class="cellrowborder" valign="top" width="25.55%" id="mcps1.3.1.2.5.2.1.1.3.2.3.1.1"><p>Parameter</p></th>
            <th align="left" class="cellrowborder" valign="top" width="74.45%" id="mcps1.3.1.2.5.2.1.1.3.2.3.1.2"><p>Description</p></th>
           </tr>
          </thead>
          <tbody>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.5.2.1.1.3.2.3.1.1 "><p><strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b2729746822433_3">Name</strong></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.5.2.1.1.3.2.3.1.2 "><p>Name of a DB2 tablespace set.</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.5.2.1.1.3.2.3.1.1 "><p><strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002200056449_b716145510445_1">Owning Host/Cluster</strong></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.5.2.1.1.3.2.3.1.2 "><p>Host or cluster to which a DB2 tablespace set belongs.</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.5.2.1.1.3.2.3.1.1 "><p><strong>Owning Instance</strong></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.5.2.1.1.3.2.3.1.2 "><p>Instance to which a DB2 tablespace set belongs.</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.5.2.1.1.3.2.3.1.1 "><p><strong>Owning Database</strong></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.5.2.1.1.3.2.3.1.2 "><p>Database to which a DB2 tablespace set belongs.</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.5.2.1.1.3.2.3.1.1 "><p><strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b925671019379_1">SLAs</strong></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.5.2.1.1.3.2.3.1.2 "><p>If an SLA has been associated with a DB2 tablespace set, the SLA name is displayed. Otherwise, <span class="uicontrol"><b>--</b></span> is displayed.</p></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.5.2.1.1.3.2.3.1.1 "><p><strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b2087113375371_1">SLA Compliance</strong></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.5.2.1.1.3.2.3.1.2 ">
             <div class="p">
              Whether a backup job is successfully executed based on the backup interval or backup window set in the SLA.
              <ul id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_en-us_topic_0000002164820450_ul1823814519293_1">
               <li id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_en-us_topic_0000002164820450_li9238184572919_1"><strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_en-us_topic_0000002164820450_b1092516394564_1">Met</strong>: If the backup time of a backup job (except for the first full backup) meets the backup time window or backup interval requirements and the backup job is executed successfully, SLA compliance is met.</li>
               <li id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_en-us_topic_0000002164820450_li189142052112912_1"><strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_en-us_topic_0000002164820450_b541520442564_1">Missed</strong>: If the backup time does not meet the backup time window or backup interval requirements, for example, if the backup interval set in the SLA for a backup job is once every half an hour but the backup time exceeds half an hour, SLA compliance is missed. In this case, you are advised to adjust the backup interval or backup window.</li>
              </ul>
             </div></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.5.2.1.1.3.2.3.1.1 "><p><strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b5758164315376_1">Protection Status</strong></p></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.5.2.1.1.3.2.3.1.2 "><p>Whether a DB2 tablespace set has been protected.</p>
             <ul>
              <li id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_li11611621173118_1"><strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b884464214219_1">Unprotected</strong>: The current resource is not associated with an SLA, or the resource is associated with an SLA but protection is disabled.</li>
              <li id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_li761111211312_1"><strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b10824655184216_1">Protected</strong>: The current resource is associated with an SLA and protection is activated.</li>
              <li id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_li2088261163715_1"><strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b67140854310_1">Creating</strong>: The current resource is associated with an SLA and protection is being created.</li>
             </ul></td>
           </tr>
           <tr>
            <td class="cellrowborder" valign="top" width="25.55%" headers="mcps1.3.1.2.5.2.1.1.3.2.3.1.1 ">
             <div class="p">
              <strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b827118125517_3">Tag</strong>
              <div class="note" id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_note1330311543247_3">
               <span class="notetitle"> NOTE: </span>
               <div class="notebody">
                <p id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_p630385412417_3"><span id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_ph5374928181810_3">This parameter is available only in 1.6.0 and later versions.</span></p>
               </div>
              </div>
             </div></td>
            <td class="cellrowborder" valign="top" width="74.45%" headers="mcps1.3.1.2.5.2.1.1.3.2.3.1.2 "><p>If a tag has been added for the resource, the tag name is displayed. Otherwise, <strong id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002164820458_b1959642011219_3">--</strong> is displayed.</p></td>
           </tr>
          </tbody>
         </table>
        </div></li>
       <li>Click a name and check the overview, copy information, and related jobs. 
        <ul id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002200056449_ul610053152120">
         <li id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002200056449_li910016322113">Overview<p id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002200056449_en-us_topic_0000002164820458_p18940145516325"><a name="EN-US_TOPIC_0000002200056449__en-us_topic_0000002200056449_li910016322113"></a><a name="en-us_topic_0000002200056449_li910016322113"></a>Display the SLA information, job execution time, and total number of copies.</p></li>
         <li id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002200056449_li17100173162115">Copy data<p id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002200056449_en-us_topic_0000002164820458_p565454392218"><a name="EN-US_TOPIC_0000002200056449__en-us_topic_0000002200056449_li17100173162115"></a><a name="en-us_topic_0000002200056449_li17100173162115"></a>You can search for copies by year, month, and day.</p> <p id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002200056449_en-us_topic_0000002164820458_p6521122942916">If <span><img id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002200056449_en-us_topic_0000002164820458_image7611125417346" src="en-us_image_0000002164820646.png"></span> is displayed below the time, a copy exists at the time.</p></li>
         <li id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002200056449_li61008392112">Operation<p id="EN-US_TOPIC_0000002200056449__en-us_topic_0000002200056449_p101003314212"><a name="EN-US_TOPIC_0000002200056449__en-us_topic_0000002200056449_li61008392112"></a><a name="en-us_topic_0000002200056449_li61008392112"></a>Displays all jobs related to a database, such as backup, restoration, and replication jobs. You can choose to display ongoing or historical jobs.</p></li>
        </ul></li>
      </ol> <p></p></li>
    </ol>
   </div>
  </div>
  <div>
   <div class="familylinks">
    <div class="parentlink">
     <strong>Parent topic:</strong> <a href="en-us_topic_0000002200142005.html">DB2 Cluster Environment</a>
    </div>
   </div>
  </div>
 </body>
</html>